USE [CTEM-DB-v1]
GO

/****** Object:  StoredProcedure [dbo].[Employee_GetAll]    Script Date: 02/10/2012 11:25:26 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		TienDH
-- Create date: 12/05/2011
-- Description:	Get full employee's information
-- =============================================
CREATE PROCEDURE [dbo].[Employee_GetAll]
AS
BEGIN
	SELECT	E.EmployeeID, E.Username,E.Password,E.FullName,
			E.Address,E.Email,E.Note,
			E.RoleID, E.RightsValue,E.CMND,
			E.DOB,E.PhoneNumber, E.IsActive, E.TotalDebt, R.RoleName
	FROM	Employee E JOIN Role R ON E.RoleID = R.RoleID	
END

GO

